SPACE MISSION ANALYSIS

Global Space Mission Performance and Trends

This Power BI dashboard provides a comprehensive analysis of global space missions, offering key insights into mission status, performance trends, and the contributions of various companies and locations. It serves as a valuable tool for understanding the historical landscape and current state of space exploration.

Project Overview & Analytical Goals

The primary goal of this project was to visualize and analyze historical space mission data to:

• Track the total number of space missions and their outcomes (success, partial failure, failure, prelaunch failure).
• Identify the top-performing companies and their successful mission counts.
• Analyze the trend of space missions over time to identify periods of increased or decreased activity.
• Pinpoint the most successful launch locations globally.
• Understand the distribution of missions by rocket status.
• Provide an overview of the number of companies involved in space missions.

Data Source

The data used for this dashboard was sourced from publicly available historical space mission records. The dataset was clean and well-structured, requiring no extensive data cleaning or transformation steps prior to analysis.

Methodology

1. Data Loading and Model Setup: The clean space mission dataset was loaded into Power BI Desktop. A star schema data model was established, if applicable, to ensure efficient querying and relationships between relevant tables.
2. DAX Calculations: Essential measures were created using DAX (Data Analysis Expressions) to summarize the key performance indicators (KPIs) presented on the dashboard:
   • Total No of Missions: 4,630
   • Total Successful Missions: 4,162
   • Total Partial Failure: 107
   • Total Failed Missions: 357
   • Total Prelaunch Failure: 4
   • Total No of Companies: 62
3. Interactive Dashboard Design: The dashboard was designed for clarity and interactivity, featuring:
   • Prominent KPI cards for overall mission statistics.
   • Bar charts illustrating 'TOP (5) MOST SUCCESSFUL MISSIONS BY COMPANY' and 'TOP (5) LOCATIONS WITH SUCCESSFUL MISSIONS'.
   • Pie charts for '% OF MISSIONS BY MISSION STATUS' and 'MISSION BY ROCKET STATUS' to show distributions.
   • A line chart for 'MISSION TREND BY YEAR' to visualize historical activity.
   • Interactive slicers for 'COMPANY' and 'Mission Status' to allow users to filter the dashboard for specific insights.

Key Findings & Insights

• Overall Mission Success Rate: Out of a total of 4,630 space missions** analyzed, an impressive 4,162 missions were classified as successful**, translating to a remarkable success rate of approximately **89.9%**. This high success rate underscores the significant advancements and reliability achieved in space technology and operational execution over the years.
• Leading Historical Contributor: Historically, **RVSN USSR emerges as the leading entity with the highest number of successful missions**, a testament to its pivotal and extensive contributions to space exploration during its operational period. This highlights the long-standing efforts and foundational impact of established space agencies.
• Most Successful Launch Location: The analysis identifies **Site 31/6, Baikonur Cosmodrome, Russia, as the most prolific and successful launch location globally**. This site's extensive history and consistent high number of successful launches solidify its status as a critical hub in the global space industry.
• Mission Activity Trends Over Time: The **'MISSION TREND BY YEAR' line chart reveals fluctuations in annual mission activity**, with a **notable increase observed around 2020**. This recent surge suggests a renewed global interest, the emergence of new private actors, or enhanced launch capabilities, potentially heralding a new era of intensified space exploration.
• Detailed Breakdown of Mission Outcomes: Beyond successes, the dashboard meticulously categorizes other mission outcomes: **107 partial failures, 357 outright failures, and 4 prelaunch failures**. This detailed breakdown provides critical visibility into the challenges faced in space missions, allowing for targeted analysis of failure types and frequencies, which is crucial for risk mitigation and continuous improvement.
• Broad Industry Participation: The dashboard reveals participation from a diverse ecosystem of **62 companies** involved in space missions. This broad involvement underscores the global and collaborative nature of space exploration, with both established national agencies and a growing number of private enterprises contributing to the collective endeavor.

Recommendations

• For Space Agencies/Companies: Analyze the success factors of top-performing companies and locations to inform best practices and improve mission reliability.
• For Industry Analysts: Use the mission trend data to forecast future activity and identify emerging patterns in space exploration.
• For Researchers: Leverage mission status and rocket type data for deeper technical analysis into causes of partial or complete failures.

Project Impact & Value Proposition

This project showcases my ability to analyze complex datasets and translate them into actionable insights using Power BI for a public-interest domain. The SPACE MISSION ANALYSIS Dashboard provides immense value by:

• Informing Stakeholders: Offering a clear and accessible overview of space mission performance to enthusiasts, researchers, and industry professionals.
• Facilitating Strategic Planning: Providing data-driven insights that can support decision-making in aerospace development and investment.
• Enhancing Transparency: Presenting a comprehensive view of global space activities and their outcomes.